Filename: tables_figs_appendix
This document contains supplementary material, mostly tables and figures, as well as some additional text and description. This web page could plausibly be rendered as a PDF or Word Doc for submission.
The tables and figures intended for the main text are here:
https://michaeldgarber.github.io/green-space-denver/tables_figs_main_text.html
As of now, this also contains all of the information presented in the main text. That is, the tables and figures presented in the main text are a subset of those presented here.
| Measure | value |
|---|---|
| area_mi2 | 154.70 |
| pop_tot | 715878.00 |
| pop_dens_mi2 | 4627.61 |
| race_w_prop | 0.54 |
| race_b_prop | 0.09 |
| race_h_prop | 0.30 |
| race_o_prop | 0.07 |
| age_med | 34.70 |
| pov_last_12_prop | 0.12 |
| hh_inc_med | 73003.00 |
| Place type | Place name | Area (acres) | Area (sq. mi.) | NDVI, mean | NDVI, 25th-ile | NDVI, 50th-ile | NDVI, 75th-ile |
|---|---|---|---|---|---|---|---|
| high diversity | Chatfield Meadow Restoration | 0.1 | 0.00 | 0.48 | 0.47 | 0.50 | 0.50 |
| high diversity | Chatfield Prairie Garden | 0.1 | 0.00 | 0.37 | 0.35 | 0.37 | 0.37 |
| high diversity | City Park Greenhouses | 0.2 | 0.00 | 0.31 | 0.27 | 0.28 | 0.28 |
| high diversity | Denver Botanic Gardens Green Roof | 0.3 | 0.00 | 0.34 | 0.34 | 0.36 | 0.36 |
| high diversity | Kenderick Lake Xeriscape Garden | 0.8 | 0.00 | 0.40 | 0.36 | 0.37 | 0.37 |
| native spectrum | Denver Botanic Gardens, 100% Native | 0.5 | 0.00 | 0.54 | 0.52 | 0.55 | 0.55 |
| native spectrum | Plains Conservation Center, 100% Native | 18.2 | 0.03 | 0.16 | 0.23 | 0.26 | 0.26 |
| native spectrum | Green Mountain Park, 85% Native | 1917.7 | 3.00 | 0.42 | 0.36 | 0.40 | 0.40 |
| native spectrum | Hogback along C-470, 75% Native | 29.7 | 0.05 | 0.36 | 0.32 | 0.35 | 0.35 |
| native spectrum | Suburban Open Space 1, Chatfield H.S., 50% Native | 3.7 | 0.01 | 0.40 | 0.37 | 0.41 | 0.41 |
| native spectrum | Suburban Open Space 2, Columbine Hills Church, 30% Native | 4.6 | 0.01 | 0.36 | 0.26 | 0.31 | 0.31 |
| native spectrum | Denver Botanic Gardens at Chatfield, 10% Native | 2.2 | 0.00 | 0.53 | 0.40 | 0.54 | 0.54 |
| native spectrum | City Park, 0% Native | 61.2 | 0.10 | 0.67 | 0.67 | 0.70 | 0.70 |
Both the State of Colorado and the City of Denver have created equity indices to guide their work. The Colorado Department of Public Health & Environment (CDPHE) describes their equity index here1 and makes the index available for download here.2 The City of Denver Department of Public Health & Environment (DDPHE) describes the neighborhood-level equity index here3 and makes the data available for download here.4
Note that for the CDPHE index, a higher score is a worse score, whereas for the DDPHE index, a lower score is a worse score. The map below presents tertiles of each score.
Figure 3.1: Comparing equity indices
Below are results of a chi-square test comparing tertiles of CDPHE Equity Index vs the DDPHE Equity index.
##
## Pearson's Chi-squared test
##
## data: table(compare_tertiles$equity_bg_cdphe_tertile_den, compare_tertiles$equity_nbhd_denver_tertile)
## X-squared = 319.81, df = 4, p-value < 2.2e-16
Note to self: This section is mostly copied from ~green-space-denver/docs/hia-results.Rmd
The weighted block-group-level mean NDVI on July 4, 2021 is presented here.
Figure 4.1: Mean normalized difference vegetation index (NDVI) of census block groups in Denver, Colorado (excluding some in the northeast, described in main text) on July 4, 2021 as measured by the Landsat-8 satellite on July 4, 2021. NDVI is measured at a spatial resolution of 30 meters squared. The weighted block-group-level mean NDVI is weighted by the proportion Landsat pixels overlap the water-free land area of the block group
For each definition of native-plants NDVI, We excluded census blocks whose baseline NDVI was above the threshold. This map visualizes the NDVI cutoffs both for lower of the two values, that of the Denver Botanic Gardens Green Roof, and the higher of the two, that of Denver Botanic Gardens Native Plot.
We measured NDVI in a 200-foot buffer, a 100-foot buffer, and a 50-foot buffer around all bodies of water in Denver. We downloaded bodies of water from OpenStreetMap (code here). We defined residential exposure to these riparian areas as those individuals living within a 500-meter buffer.
The below map depicts mean NDVI in the portions of census block groups that intersect a 200-foot buffer as well as those pieces that intersect the part of the 500 m buffer that would not be intervened upon, i.e., the part between the 200-foot buffer and the edge of the 500 m residential buffer.